2013-05-24 - 5996.200 - Enhancement - Changes to SA170 #CrystalReportsSupport

ENHANCEMENT

5996.200 - Changes to SA170

Requirement Summary

---

Need to add two additional dynamic groupings, TOP N Customers and new currency to SA170 report.

Admin Info

---

Purpose	Need to add two additional dynamic groupings, TOP N Customers and new currency to SA170 report.
Requested By	Steven Hayes
Spec Created By	Naga Brahmam R
Spec Created Date	05/24/2013
Spec QA by	Uday Kumar P
Objects	SA170
Document Status	Complete

References

---

Prior Tickets

7006 - BI - SA170 - New Drill Down
7158 - BI - SA170 - New Currency

Documents

None

Functional Requirement

---

The following changes need to be made for the SA170 report:
1. Add EURO Currency in the prompt panel where there is only GBP and USD.
2. Add new dynamic groupings for drill-down:
a. Region / Sales Manager / Country / Sales Rep/ Customer
b. Region / Sales Manager / Sales Rep / Customer
3. Add Top N Customers by Shipped Revenue.

Solution Summary

---

We have added the EURO currency at the prompt level, additional dynamic groupings for drilldown and we also applied Top N customer by Shipped Revenue for the report.

Test Plan

SNo	Test Scenario	Expected Results
1	Compare the existing group with the SA170 Production Report	Report values should be identical
2	Compare the new dynamic groupings with BEx query output	Report values should be identical

Solution Details

---

1. We have added the EURO currency at the prompt panel for the report and now it displaying USD, GBP and EURO parameters in the report.
2. We have created dynamic groupings with newly added groups for drill-down:
a. Region / Sales Manager / Country / Sales Rep
b. Region / Sales Manager / Sales Rep / Customer
3. We have also applied Top N Customers by Shipped Revenue at Group level 5.

Issues

---

None